2012-08-20 - 4804.100 - Rel Notes - License Scorecard #BIReleases2012

Release Notes

4804.100 - License Scorecard

Admin Info


Purpose
Need to develop License Scorecard report.
Release No
001
Submitted
08/20/2012
Submitted by
Mallareddy D
Source/Destination Systems
Remote Machine to IT > BMS > Production Folder in Dev Server
Release Sent To
Mark Harris
Object(s) Created By
Mallareddy D
Object(s) Tested By
Mallareddy D

Technical Objects


SA140

Release Notes


For Infrastructure

None

For Requestor

1) Report showing the grouping as Region > Sales Org > License.
2) Report shows this year Shipped revenue YTD, Open revenue YTD, Total Revenue YTD, Last Year Shipped Revenue YTD, Shipped % Last Year and Total % Last Year. This is shown in Top left corner of the report.
3) Report with same info mentioned in point 2 and showing only for hot market in top right corner of the report.
4) Total Revenue YTD = Shipped Revenue YTD + Open Revenue YTD.
5) LY Shipped YTD % = Actual Revenue Shipped Current YTD/ Last Year Total Revenue * 100.
6) LY Shipped Year % = Actual Revenue Current Year/ Last Year Total Revenue * 100.
7) Total LY YTD % = Current Year Total YTD Revenue / Last Year Total Revenue * 100.
8) Total LY Year % = Current Year Total Revenue / Last Year Total Revenue * 100.
9) Report shows Shipped Collection, Open Collection, Shipped Product Lines, Open Product Lines, Shipped Product Styles, Open Product Styles, Shipped Customer and Shipped Concessionaire.
10) Report shown Current Year Revenue, Current Year Quantity, Previous Year Quantity and Previous Year Revenue for all the sections mentioned in point 9.
11) Along with above definition, report shows service level information.
12) Service level information includes Ordered Ontime, Ordered Fill Rate, Confirmed Ontime, Confirmed Fill Rate and First Pass.
13) All KPI's mentioned in point 12 and shows the information for Current Year and Previous Year.

Test Notes

SNo.
Test Scenario
Expected Results
1.
Checked the report values with BEx query
Values are identical.
2.
Checked the report against NEC Crystal standards
Report passes the QA standards.

Reference Document(Specification)


2012-08-20 - 4804.100 - Spec - License Scorecard